UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zT4Fnn4rW3jA1EqhIqgn0kFuHrheZw/nC5eWuVh4vzU='
WHERE
key_id = 'c38a0554d70c09c6bc307b24d5bfe53401fea74586787dd1aa35cd035d480ec9'
AND (
token = 'zT4Fnn4rW3jA1EqhIqgn0kFuHrheZw/nC5eWuVh4vzU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)