UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xYTXhKBXmKwnlGph7loIMWgZ3RsATMnCDk0nPZGTlcs='
WHERE
key_id = '679c15ed8b2d116b9540e8731df513133104860e76ca1f15f8d4599c806128cc'
AND (
token = 'xYTXhKBXmKwnlGph7loIMWgZ3RsATMnCDk0nPZGTlcs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)