UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'isvMCm4AZrJTzaeyz2HAcIzaa/jrQuC45z9X/Nz3Uxw='
WHERE
key_id = 'b48769e41f2be638bcf51873078437ed88e964eda10e4cfa56774b33994f4e96'
AND (
token = 'isvMCm4AZrJTzaeyz2HAcIzaa/jrQuC45z9X/Nz3Uxw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)