UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pwoYUIUFT2eORt4LhsFiUaUvsNrS12zxQ3yFw7SqLRs='
WHERE
key_id = 'd1c89871a49864881b6abca88f5a6ab2a4a8985956b3dcadfdf3fe4e1b46ea11'
AND (
token = 'pwoYUIUFT2eORt4LhsFiUaUvsNrS12zxQ3yFw7SqLRs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)