UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'D3NMluM0BVk4bhGilYM1+EJWRcAuoCJT2/48V8FH0RI='
WHERE
key_id = 'd80855cd4ded52b9ff57ac530bf1f01916de1e998a4785b30a6f77a8d0d69909'
AND (
token = 'D3NMluM0BVk4bhGilYM1+EJWRcAuoCJT2/48V8FH0RI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)