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