UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KJHAo7Ad2QxSTECtbseQDO3mZiG7vBZmjey8NGOkvV4='
WHERE
key_id = '08065095d299e0a09dc0a16e34940a4ebf5c2957def9e53f7ffcb07cd647b84c'
AND (
token = 'KJHAo7Ad2QxSTECtbseQDO3mZiG7vBZmjey8NGOkvV4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)