UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'p1aI7Qa2JFqlXX6cq8iEv5SJEy8XN/DSSLtSFzRG8W4='
WHERE
key_id = '801275c4314babbde04b31d9eefb14af4bc27a78f5e138b56e17090221dc2b4a'
AND (
token = 'p1aI7Qa2JFqlXX6cq8iEv5SJEy8XN/DSSLtSFzRG8W4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)