UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6GeJQnEvuxhmjd2VqVeDcETXwdfsUxPpVNw0NSr8NOU='
WHERE
key_id = 'c34156fc35e9027da9953da94de9436e52812da7b2341d03fd5653971dee3dc7'
AND (
token = '6GeJQnEvuxhmjd2VqVeDcETXwdfsUxPpVNw0NSr8NOU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)