UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'uD28NwqxfIzTa+7hFnALaFLLuYvFN+2bjupqTsdoOn0='
WHERE
key_id = '564c6813f518b15c154e8f6f2c84388af2155ad8907a453da821c3ebe266b319'
AND (
token = 'uD28NwqxfIzTa+7hFnALaFLLuYvFN+2bjupqTsdoOn0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)