UPDATE 
  cscart_aprillock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '5XcfRQY7IvU4/MlQmwwvVHQOTpM6P1ZfhCsXzXAoVhw=' 
WHERE 
  key_id = 'bc88a78f37f9f96cf3df11b7176368f6b11f10d8d069a9b5c408f59198e4edf1' 
  AND (
    token = '5XcfRQY7IvU4/MlQmwwvVHQOTpM6P1ZfhCsXzXAoVhw=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00039