UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Dce/hsX65zXJIgjhDgXfyt5kjgXUaQSjHtGX+YXRf+4='
WHERE
key_id = '42ba6d3c2bf007c6887ed7c75f890bc0516a2fa38380ba3b833ca8fd0d168e3e'
AND (
token = 'Dce/hsX65zXJIgjhDgXfyt5kjgXUaQSjHtGX+YXRf+4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)