UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NsnCCa8RwZ+3aK5NzyGTFLOkgkB1Aa2QFTaXfJxQE6s='
WHERE
key_id = '727a334ad1aabbab2020696e95b5963841f723aa8b5c3bd21b52985426a897e0'
AND (
token = 'NsnCCa8RwZ+3aK5NzyGTFLOkgkB1Aa2QFTaXfJxQE6s='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)