UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QzUqhprlWxT55Q20Q77WPpeY64ztWCoAnvrTAvURgoQ='
WHERE
key_id = '172190ce2950784ce156c465654fdb975677dd768406c447a34f3dd420679c38'
AND (
token = 'QzUqhprlWxT55Q20Q77WPpeY64ztWCoAnvrTAvURgoQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)