UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'sTE7w5tiVoV+nn+ccXD0+E5IGMV5P33WzTUWT6mc5dM='
WHERE
key_id = '9fb59af549b9f9898debf82f8ad3614b203eb805033492e435680ef9757d8884'
AND (
token = 'sTE7w5tiVoV+nn+ccXD0+E5IGMV5P33WzTUWT6mc5dM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)