UPDATE 
  cscart_aprillock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'LsEqZf+iJFOVAyV7SQhPqkTqofvkFELEDo/WbO+AtIc=' 
WHERE 
  key_id = 'c5d93a59a9001e370128a305f6410b083fdf7f0778a605277f4114fe679eb6ec' 
  AND (
    token = 'LsEqZf+iJFOVAyV7SQhPqkTqofvkFELEDo/WbO+AtIc=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00036