UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1nPqHC1BoAGqaSoUoUb35hjpP2VOZlhURskwfJljjlE='
WHERE
key_id = 'a99cd0d86dad4d6e15a4a65623c58b075a162baa0793055e53bd86903f34c8bb'
AND (
token = '1nPqHC1BoAGqaSoUoUb35hjpP2VOZlhURskwfJljjlE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)