UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'MCe9QmJjsDPG9CBBVsKkpxMJR7w0IaBWEZRK7nEw92o='
WHERE
key_id = '20ca9172d208b5b35624b2389b9625ecf5d1fcc340b43d8e1776623d495182e5'
AND (
token = 'MCe9QmJjsDPG9CBBVsKkpxMJR7w0IaBWEZRK7nEw92o='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)