UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1+szkLvsv5fMiuKvwttSylwqSodSgyifgBBkqzjv1fg='
WHERE
key_id = 'cefd384ae1f7e6421e27c92e93873f07b2bcc9bf4c76bbf6566772eede991faa'
AND (
token = '1+szkLvsv5fMiuKvwttSylwqSodSgyifgBBkqzjv1fg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)