UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'D0a0k0xyCZWS/Q6VI8GoHgpAJMPpeO25WZJ6ADRKtq8='
WHERE
key_id = '6ccce008fb4c8245caa85f7c11f8e6eb4da3b8d0fc9812ec21a1c443d8885ec5'
AND (
token = 'D0a0k0xyCZWS/Q6VI8GoHgpAJMPpeO25WZJ6ADRKtq8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)