UPDATE 
  cscart_aprillock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'xbwQmH72uw8F7r+khxS2D1noABOBl1KqVFt6MgAaAOQ=' 
WHERE 
  key_id = 'a09e9ec2d33c36b02e832eb70119d612cf5a4011149b577506b9a7bf7ae540d1' 
  AND (
    token = 'xbwQmH72uw8F7r+khxS2D1noABOBl1KqVFt6MgAaAOQ=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00026