UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'eaYYfq7WK+rnWlf3VDInRGGUBeQLbEUcgikUIp5bxtU='
WHERE
key_id = '56f707eff5c1c5f953b0acac9fdcf4bccac4bb217440400af694180a60cbd53a'
AND (
token = 'eaYYfq7WK+rnWlf3VDInRGGUBeQLbEUcgikUIp5bxtU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)