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