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