UPDATE 
  cscart_aprillock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '8cPGXVTc+6uqXqYqNdtK2sYzaFDzY/8acshKkZeDnxA=' 
WHERE 
  key_id = 'fa54f64dff453849bc62f982caa088439a396e7233aad61ade23ffc91cd841a0' 
  AND (
    token = '8cPGXVTc+6uqXqYqNdtK2sYzaFDzY/8acshKkZeDnxA=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00033