UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NHpmDy8R/8ipPpH1gAC54owHbLJT/DAg6E5pN7FbDFw='
WHERE
key_id = '46d817b18940ee9af7e2e0c29c5a24b2a9c93b098612f0d426575069710793bd'
AND (
token = 'NHpmDy8R/8ipPpH1gAC54owHbLJT/DAg6E5pN7FbDFw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)