UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'V5LSdJNvWEWl8mecIxqqQPTtY4g8gXJ2h2RYoxsZ9Z8='
WHERE
key_id = '78e298b4ccc48eb9e6d7d5648e4d3532c4826bf75f1876e8350ac5b12e66e78a'
AND (
token = 'V5LSdJNvWEWl8mecIxqqQPTtY4g8gXJ2h2RYoxsZ9Z8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)