UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Y827njiidmT8NZ2odlFhe77PvafRu8zMYRBG9i1ObHQ='
WHERE
key_id = 'd1d5b24d29a95894aee1c6ee95439c9aa90dde882f35511d53ce04d81078da8a'
AND (
token = 'Y827njiidmT8NZ2odlFhe77PvafRu8zMYRBG9i1ObHQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)