UPDATE 
  cscart_aprillock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '3CgTyP8iTjdSlV9t1h623QoYUPnRExXq23XQUqjcLfQ=' 
WHERE 
  key_id = '9171243aed951a405663a5eeccb26cd537cc5f30b9d2d42203853858657d7cfd' 
  AND (
    token = '3CgTyP8iTjdSlV9t1h623QoYUPnRExXq23XQUqjcLfQ=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00034