UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9sB8w2KKr46hSyq9CNeM7pjPN1yUJoo4AN7saoCMRcU='
WHERE
key_id = 'a2162806f49052c602193e2c00014996400cdc73250f134711e23e6bd97a243f'
AND (
token = '9sB8w2KKr46hSyq9CNeM7pjPN1yUJoo4AN7saoCMRcU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)