UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'RY5Tn7H0rbukb4yC/94qyOWkW5SJDKzgeo4FYypq6sA='
WHERE
key_id = 'c05f0505a9fabffea955ab8ddc34b5d27e066310700d847a3721e92af387de77'
AND (
token = 'RY5Tn7H0rbukb4yC/94qyOWkW5SJDKzgeo4FYypq6sA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)