UPDATE 
  cscart_aprillock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'WTZ5nYFGf1a0RkahcH+u6Pe5P1GLkfJggo07B3I6v7Y=' 
WHERE 
  key_id = '48401db03bfb7f139d2ce14be47c73c3ac2e5a00562dfd92f94d0947a5b181bd' 
  AND (
    token = 'WTZ5nYFGf1a0RkahcH+u6Pe5P1GLkfJggo07B3I6v7Y=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00032