UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4NsT47X2DSBEf00Cl0mOxPjdTrYWTjaZVCuM4HGTsPI='
WHERE
key_id = '92697e5c7fb39f1ea3cf61e5354a160c806e588464b75219d45f08e846135a6a'
AND (
token = '4NsT47X2DSBEf00Cl0mOxPjdTrYWTjaZVCuM4HGTsPI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)