UPDATE 
  cscart_aprillock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '2AlJRtIE+5/J1QZQfZ4WpD+E9EZMpCFe9yfpWdwqhXc=' 
WHERE 
  key_id = 'eef24bffe176201d8899cc6750962522bf4bc765f193d6c87447b351c8d8e002' 
  AND (
    token = '2AlJRtIE+5/J1QZQfZ4WpD+E9EZMpCFe9yfpWdwqhXc=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00031