UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'UISC3JoLaJBqUHSbFss1HYvwNIhhMvIgI9T89UJ0kxM='
WHERE
key_id = '8bb16d4bf96fd5dece6dc35a5ecddb7125b3cbaf9b64712202758d21d709a960'
AND (
token = 'UISC3JoLaJBqUHSbFss1HYvwNIhhMvIgI9T89UJ0kxM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)