UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tL0B8PjIJJiksRHDfXOeDY8oWsmyui9nN21xItZMKWw='
WHERE
key_id = '807e55297a20ce8d0458f062e822c2290657bc109b040a3c9b00c6e493950b91'
AND (
token = 'tL0B8PjIJJiksRHDfXOeDY8oWsmyui9nN21xItZMKWw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)