UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'y5TRcBs1BczeNUuN5cOuAM9NH6VpJw0pnmA3oPovtXU='
WHERE
key_id = 'f38c387368c52824a824e7fd9f701df919ae57996138a0fe4605fef218ad0698'
AND (
token = 'y5TRcBs1BczeNUuN5cOuAM9NH6VpJw0pnmA3oPovtXU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)