UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'FZi4dn/RRFO800LuIX1cXYLLcb0v1rXwQrcqxNGS/tU='
WHERE
key_id = 'a914c9359ab65f3403378dcc8213fb0527ca2b967d0a0b24fbfbaf3b5023f253'
AND (
token = 'FZi4dn/RRFO800LuIX1cXYLLcb0v1rXwQrcqxNGS/tU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)