UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '87ao4IxdqOlL26Zb9OgVfnSXWE0Rqt0RNvKRd2jqg24='
WHERE
key_id = '935212a332d6d944d52a45faca5d9f2707ed432e93171a334ded43f8688278a1'
AND (
token = '87ao4IxdqOlL26Zb9OgVfnSXWE0Rqt0RNvKRd2jqg24='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)